package com.atguigu.gmall.publisherlj.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Author 晶晶
 * @Date 2023 03 29 14 32
 **/
public interface TradeProvinceMapper {

    @Select("select \n" +
            " province_name,\n" +
            " sum(order_count) order_count,\n" +
            " sum(order_user_id_count) order_user_id_count,\n" +
            " sum(order_amount) order_amount\n" +
            " from dws_trade_province_order_window\n" +
            " where toYYYYMMDD(stt) =#{date}\n" +
            " group by province_name")
    List<Map> selectTradeOrderCnt(int date);


}
